﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Configuration;

namespace BestBuy.DAL
{
    public class CCountry
    {
        private TradeKeyDataContext content = new TradeKeyDataContext();
        public CCountry()
        { }

        public List<QuocGia> GetList()
        {
            var q = (from sp in content.QuocGias
                     where sp.TinhTrang == true
                     select sp).ToList();
            return q;
        }
        public static List<QuocGia> GetIndustry()
        {
            TradeKeyDataContext ct = new TradeKeyDataContext();
            var q = (from sp in ct.QuocGias
                     where sp.TinhTrang == true
                     select sp).ToList();
            return q;
        }
    }
}